CREATE TABLE [dbo].[JOL_ApplyField]
(
[JOL_Field_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Field_ApplyCompany] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_Purpose] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_Contact] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_Action] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_ApplyTime] [datetime] NULL,
[JOL_Field_ApplyPosition] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_SeatNumber] [int] NULL,
[JOL_Field_IsProvideMultimedia] [bit] NULL CONSTRAINT [DF__JOL_Apply__JOL_F__7246E95D] DEFAULT ((0)),
[JOL_Field_IsNeedInvoice] [bit] NULL,
[JOL_Field_InvoiceBeginning] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Apply__JOL_F__733B0D96] DEFAULT ('无'),
[JOL_Field_InvoiceProject] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Apply__JOL_F__742F31CF] DEFAULT ('无'),
[JOL_Field_IsPaidMoney] [bit] NULL CONSTRAINT [DF__JOL_Apply__JOL_F__75235608] DEFAULT ((0)),
[JOL_Field_AddTime] [datetime] NULL,
[JOL_Field_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_UpdateTime] [datetime] NULL,
[JOL_Field_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_VerifyStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Apply__JOL_F__76177A41] DEFAULT ('未审核'),
[JOL_Field_VerifyUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Field_IsSendEmail] [bit] NULL CONSTRAINT [DF__JOL_Apply__JOL_F__770B9E7A] DEFAULT ((0)),
[JOL_Field_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_ApplyField_EndTime] [datetime] NULL,
[JOL_ApplyField_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_ApplyField_Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_ApplyField_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_ApplyField] ADD CONSTRAINT [PK__JOL_ApplyField__7152C524] PRIMARY KEY CLUSTERED  ([JOL_Field_No]) ON [PRIMARY]
GO
